<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  
  <title>Jailer - SQL Export</title>
  <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
  <meta name="description" content="Data Export Tool" />
  <link rel="shortcut icon" href="favicon.ico" />
  <meta name="keywords" content="data export referential integrity java jdbc dbms" />
  <link rel="stylesheet" type="text/css" href="styles.css" />
</head>

<body left-margin="0" top-margin="0">
  <div align="left">
    <table style="text-align: left; position: absolute; left: 0pt; top: 0pt;" border="0"
    cellpadding="0" cellspacing="0" height="407" width="100%">
      <tbody>
        <tr>
          <td colspan="2" class="bannerbackground" height="33" width="100%">
            <table border="0" cellpadding="4" cellspacing="0" width="100%">
              <tbody>
                <tr>
                  <td><a href="https://github.com/Wisser/Jailer"><img src="logo.png" hspace="10" /></td> <td class="slogan" width="100%"></a>

                   

                  <td style="text-align: right; width: 100%;">
                    <table border="0" cellpadding="0" cellspacing="0">
                      <tbody>
                        <tr>
                           <td><a href="https://github.com/Wisser/Jailer"><img src="GitHub-Mark-64px.png" title="GitHub" /></a> </td></tr><tr style="height: 100%;"><td>&nbsp;</td>
                        </tr>
                      </tbody>
                    </table>
                  </td>
                </tr>
              </tbody>
            </table>
          </td>
        </tr>

        <tr>
          <td colspan="2" class="nav1background"  width="100%">&nbsp;
          <b><font color="#FFFFFF"><a href="home.htm" target="_self" class=
          "tlink">&nbsp;Home&nbsp;</a> <a href="quicktour.htm" target="_self"
          class="tlink">&nbsp;Quick Tour&nbsp;</a> <a href="exporting-data.htm"
          target="_self" class="tlinkA">&nbsp;Tutorial&nbsp;</a> <a href=
          "data-browsing.html" target="_self" class="tlink">&nbsp;Data Browser&nbsp;</a> <a class="tlink" href="videos.html" target="_self">&nbsp;Videos&nbsp;</a> 
          <a href="faq.html" target="_self" class="tlink">&nbsp;FAQ&nbsp;</a> 
          <a href="api.html" target="_self" class="tlink">&nbsp;API&nbsp;</a> 
          <a href="design.htm" target="_self" class=
          "tlink">&nbsp;Documentation&nbsp;</a> <a href=
          "http://sourceforge.net/forum/?group_id=197260" target="_self" class=
          "tlink">&nbsp;Forum&nbsp;</a> <a href=
          "http://sourceforge.net/project/showfiles.php?group_id=197260" target="_self"
          class="tlink">&nbsp;Download&nbsp;</a>  &nbsp;&nbsp;&nbsp;
          &nbsp;&nbsp;&nbsp;</font></b></td>
        </tr>

        <tr>
          <td colspan="2" class="spacer" width="100%"></td> </tr><tr><td class="lmenucontainer">&nbsp;</td>
        </tr>

        <tr>
          <td class="lmenucontainer" height="100%" valign="top" width="14%">
            <div align="center">
              <center>
                <table border="0" cellpadding="0" cellspacing="0" width="100%">
                  <tbody>
                    <tr>
                      <td height="6px" width="100%"> </td>
                    </tr>
                  </tbody>
                </table>
              </center>
            </div>

            <ul>
              <li><a href="preparation.htm" target="_self" class="mlinkA">Preparation</a> </li><br>
              
              <li>Basic</li>

                <ul>
                  <li><a href="exporting-data.htm" target="_self" class="llink">Exporting Data</a> </li>

                  <li><a href="deleting-data.htm" target="_self" class="llink">Deleting
                  Data</a> </li>
                </ul>
<br>
              <li>Advanced</li>

                <ul>
                  <li><a href="filters.html" target="_self" class=
                  "llink">Filters</a> </li>
                  <li><a href="subset-by-example.html" target="_self" class=
                  "llink">Subset&nbsp;By&nbsp;Example</a> </li>
				  <li><a href="exporting-xml.html" target="_self" class="llink">JSON/YAML/XML Export</a> </li>
                </ul>
            </ul>

            <table border="0" cellpadding="5" cellspacing="0" width="100%">
              <tbody>
                <tr>
                  <td class="content2background"><img style="width: 160px; height: 1px;"
                  alt="" src="architecture-Dateien/vgradp.gif" /></td>
                </tr>
              </tbody>
            </table>

            <p>&nbsp;</p>
          </td>

          <td class="contentbackground" height="418" valign="top" width="86%">
            <div align="right">
              <table border="0" cellpadding="0" cellspacing="0" height="542" width="98%">
                <tbody>
                  <tr>
						<td class="contentbackground" height="21" width="100%">&nbsp;</td>
					</tr>

                  <tr>
                    <td class="content" height="520" valign="top" width="100%">

                      <div class="info"><p>&nbsp;<br>&nbsp;If you do not want to prepare a database yourself, you can use the included "Demo-Scott" database instead. <br>&nbsp;</p></div> <br>
                      <h4>Step 1. Setup the database<br /></div></h4>

                      <p>Create a new database schema and execute <a href=
                      "scott-tiger.sql.html"><img style=
                      "border: 0px solid ; width: 13px; height: 13px;" src=
                      "exporting-data-Dateien/arrow.gif" hspace="4" /><big><span style=
                      "font-family: monospace;"><font size=
                      "4">script/scott-tiger.sql</font></span></big></a> . Make sure that
                      the script runs successfully.<br />
                      <br /></p>

                      <table style="width: 100%; text-align: left;" border="0"
                      cellpadding="0" cellspacing="0">
                        <tbody>
                          <tr>
                            <td style=
                            "vertical-align: top; background-color: rgb(230, 255, 230);">
                            <span style="font-family: monospace;">$ db2 connect to
                            wisser</span> <span style="font-family: monospace;">user
                            wisser</span> <span style="font-family: monospace;">using
                            <span style=
                            "font-style: italic;">&lt;password&gt;</span></span><br />
                            <span style="font-family: monospace;">$ db2 -tvf
                            script/scott-tiger.sql<br /></span></td>
                          </tr>
                        </tbody>
                      </table><br />

                      <h4>Step 2. Building the data model<br /></h4>Start the Tool
                      (see <a href="installation-2.htm" target="_self">"Installation"</a> )<br><br />

                      <table style="width: 100%; text-align: left;" border="0"
                      cellpadding="0" cellspacing="0">
                        <tbody>
                          <tr>
                            <td style=
                            "vertical-align: top; background-color: rgb(230, 255, 230);">
                            <span style="font-family: monospace;">$ sh
                            jailerGUI.sh</span><br /></td>
                          </tr>
                        </tbody>
                      </table>

                      <p>and create a new data model. Press <span style=
                      "font-style: italic;">New</span> and enter "Tutorial" as the name
                      for the new model.</p>

                      <p><img style="width: 697px; height: 280px;" alt="" src=
                      "screenshot4.1.gif" /><br /></p>

                      <p><br />
                      A data model holds information about the tables in the database and
                      all associations between them.<br />
                      Most of the information can be retrieved automatically by analyzing
                      the database schema.<br />
                      <br />
                      Click on <span style="font-style: italic;">Analyze
                      Database</span>.<br />
                      You will be asked for the database connection
                      information.<br /></p>

                      <p><img style="width: 655px; height: 328px;" alt="" src=
                      "screenshot4.2.gif" /></p>

                      <p>Create a new connection.<br /></p>

                      <p><img style="width: 409px; height: 316px;" alt="" src=
                      "dbs1.gif" /><br />
                      <br /></p>

                      <p>Select the DBMS you are using from the displayed list, and fill
                      out the following form:<br /></p><img style=
                      "width: 570px; height: 369px;" alt="" src=
                      "screenshot4.3.gif" /><br />

                      <p><br />
                      Finally click on <span style=
                      "font-style: italic;">Connect</span><span style=
                      "font-style: italic;">.</span> Jailer finds seven tables and five
                      associations:<br />
                      <br />
                      <img src="exporting-data-Dateien/screen3.png" /><br />
                      <br />
                      <br />
                      Two associations are still missing:<br /></p>

                      <ul>
                        <li>an employee is classified into a salary grade depending on
                        his salary</li>

                        <li>employees may receive bonuses</li>
                      </ul>

                      <br>
                      Add the definitions manually (<big><span style="font-family: monospace;"><span style="font-family: mon;"><span style="font-style: italic;">Add</span>-</span></span></big>Button under
                      <big><span style="font-family: monospace;"><font size="4">Associations</font></span></big>):<br>
                      <br>
                      <img src="exporting-data-Dateien/screen4.png"><br>
                      <br>
                      <img src="exporting-data-Dateien/screen42.png"><br>
                      <br>
                      The data model is&nbsp;now complete.<br>
                      <br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
                      <br />

                      <p><br /></p>

                      <p><br />
                      <br /></p>
                    </td>
                  </tr>
                </tbody>
              </table>
            </div>

            <p>&nbsp;</p>
          </td>
        </tr>

        <tr>
          <td height="12" valign="top" width="14%"><br /></td>

          <td><br /></td>
        </tr>
      </tbody>
    </table>
  </div>
</body>
</html>
